Databases

Database

Candidates should be able to:

1. Define a single-table database from given data storage requirements

Note and guidance

• Including:
  • fields
  • records
  • validation

2. Suggest suitable basic data types

Note and guidance

• Including:
  • text/alphanumeric
  • character
  • Boolean
  • integer
  • real
  • date/time

3. Understand the purpose of a primary key and identify a suitable primary key for a given database table

4. Read, understand and complete structured query language (SQL) scripts to query data stored in a single database table

Note and guidance

• Limited to:
  • SELECT
  • FROM
  • WHERE
  • ORDER BY
  • SUM
  • COUNT
• Identifying the output given by an SQL statement that will query the given contents of a database table